package com.school.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;

/**
 * @Description  荣誉证书表
 * @Author
 * @Date 2021-04-06 16:43:28 
 */
@Data
@Entity
@Table ( name ="certificate_honor" , schema = "public")
public class CertificateHonor implements Serializable {

	private static final long serialVersionUID =  5896955519967189656L;

	/**
	 * 编号
	 */
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
   	@Column(name = "id" )
	private Integer id;

	/**
	 * 学生信息ID
	 */
   	@Column(name = "student_id" )
	private String studentId;

	/**
	 * 名称
	 */
   	@Column(name = "name" )
	private String name;

	/**
	 * 等级
	 */
	@Column(name = "level" )
	private String level;

	/**
	 * 类型
	 */
	@Column(name = "type" )
	private String type;

	/**
	 * 文件
	 */
	@Column(name = "files" )
	private String files;

	/**
	 * 颁发机构
	 */
   	@Column(name = "issuer_authority" )
	private String issuerAuthority;

	/**
	 * 颁发时间
	 */
   	@Column(name = "issue_time" )
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
	private Date issueTime;

	/**
	 * 结束日期
	 */
	@Column(name = "end_date" )
	@DateTimeFormat(pattern = "yyyy-MM-dd") //入参
	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd") //出参
	private Date endDate;

	/**
	 * 创建者
	 */
   	@Column(name = "create_by" )
	private String createBy;

	/**
	 * 创建时间
	 */
   	@Column(name = "create_date" )
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
	private Date createDate;

	/**
	 * 更新者
	 */
   	@Column(name = "update_by" )
	private String updateBy;

	/**
	 * 更新时间
	 */
   	@Column(name = "update_date" )
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
	private Date updateDate;

	/**
	 * 删除标记
	 */
   	@Column(name = "del_flag" )
	private String delFlag;

	/**
	 * 描述文字
	 */
	@Column(name = "content" )
	private String content;

}
